What is inline hint in Oracle?
Could you please elaborate on the concept of inline hint in Oracle? I'm curious to understand how it differs from other types of hints and what specific purpose it serves in optimizing SQL queries. How does it work under the hood, and what are some practical scenarios where its use could be beneficial? Additionally, are there any potential drawbacks or limitations to consider when utilizing inline hints in Oracle?